export const RoleQueries = {
    GetRoles: `
    SELECT
      id,
      roleName,
      roleDescription,
      rolePermissions
    FROM my_schema.role
    `,
  
    GetRoleById: `
    SELECT
      id,
      roleName,
      roleDescription,
      rolePermissions
    FROM my_schema.role
    WHERE
      id = ?
    `,

    GetRolesByIds: `
    SELECT
      roleName,
      rolePermissions
    FROM my_schema.role
    WHERE
      id in ?
    `,
  
    AddRole: `
    INSERT INTO my_schema.role (roleName, roleDescription, rolePermissions)
      VALUES ?
    `,

    UpdateRoleById: `
    UPDATE my_schema.role
    SET ?
    WHERE
      id = ?
    `,
  
    DeleteRoleById: `
    DELETE FROM my_schema.role
    WHERE
      id = ?
    `
  };